
<!DOCTYPE html>
<html>
<head>
	<title></title>
	<style type="text/css">
		table{border-collapse:collapse;border-spacing:0;border-left:1px solid #888;border-top:1px solid #888;background:#efefef;}
th,td{border-right:1px solid #888;border-bottom:1px solid #888;padding:5px 15px;}
th{font-weight:bold;background:#ccc;}

		td{
			min-width: 30px;
		}

	</style>
</head>
<body>


<?php

 	include 'db_account.php';
	 

	// Create connection
	$conn = mysql_connect($servername, $username, $password);
	if ($conn->connect_error) {
	    die("Connection failed: " . $conn->connect_error);
	} 
	mysql_select_db($dbname, $conn);

	$sql = "select * from xindongfang_user order by weibo";

	$result = mysql_query($sql, $conn);
?>
	<table>
		<tr>
			<td>序号</td>
			<td>微博</td>
			<td>提取码</td>
			<td>收货人姓名</td>
			<td>收货人手机</td>

			<td>省</td>
			<td>市</td>
			<td>区</td>
			<td>街道及房号</td>
		</tr>
<?php
    $current = 0;
	while($row = mysql_fetch_array($result)){
		$current++;
?>
		<tr>
			<td><?php echo $current ?></td>
		    <td><?php echo $row[weibo]?></td>
			<td><?php echo $row[code]?></td>
			<td><?php echo $row[name]?></td>
			<td><?php echo $row[phone]?></td>

			<td><?php echo $row[province]?></td>
			<td><?php echo $row[city]?></td>
			<td><?php echo $row[area]?></td>
			<td><?php echo $row[street]?></td>
		</tr>
<?php
	}

?>
	</table>
<?php
	mysql_close($conn);

?>


</body>
</html>